using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using SysFrame.Message;
using System.Reflection;
using System.Data;
using MySql.Data.MySqlClient;

namespace SysFrame.BP
{
    /// <summary>
    /// system_5方法
    /// </summary>
    public class MySQLsystem_5 : Isystem_5
    {

        /// <summary>
        /// 得到system_5实体
        /// </summary>
        /// <param name="msq">条件</param>
        /// <returns></returns>
        public List<Mssystem_5> Getsystem_5MsByQuery(MsQuery msq)
        {
            List<Mssystem_5> listms = new List<Mssystem_5>();
            StringBuilder sb = new StringBuilder();
            List<string> lstCmdText = new List<string>();
            sb.Append("select system_5.* ");
            sb.Append(" from system_5 ");
            sb.Append(" where 1=1 ").Append(msq.strquery);
            if (msq.strorder != null && msq.strorder != "")
            {
                sb.Append(" order by ").Append(msq.strorder);
            }
            lstCmdText.Add(sb.ToString());
            sb.Remove(0, sb.ToString().Length);
            try
            {
                DataSet ds = DbHelperMySQL.Query(lstCmdText[0].ToString());
                if (ds != null && ds.Tables.Count != 0 && ds.Tables[0].Rows.Count != 0)
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        Mssystem_5 ms = new Mssystem_5();
                        if (dr["System_5_10"].ToString() != "") { ms.System_5_10 = int.Parse(dr["System_5_10"].ToString()); }
                        if (dr["System_5_20"] != null) { ms.System_5_20 = dr["System_5_20"].ToString(); }
                        if (dr["System_5_30"] != null) { ms.System_5_30 = dr["System_5_30"].ToString(); }
                        if (dr["System_5_40"] != null) { ms.System_5_40 = dr["System_5_40"].ToString(); }
                        if (dr["System_5_50"] != null) { ms.System_5_50 = dr["System_5_50"].ToString(); }
                        if (dr["System_5_60"] != null) { ms.System_5_60 = dr["System_5_60"].ToString(); }
                        if (dr["System_5_70"] != null) { ms.System_5_70 = dr["System_5_70"].ToString(); }
                        if (dr["System_5_80"] != null) { ms.System_5_80 = dr["System_5_80"].ToString(); }
                        if (dr["System_5_90"] != null) { ms.System_5_90 = dr["System_5_90"].ToString(); }
                        if (dr["System_5_100"] != null) { ms.System_5_100 = dr["System_5_100"].ToString(); }
                        listms.Add(ms);
                    }
                }
            }
            catch { }
            return listms;
        }

        public string GetMaxTypeCode()
        {
            StringBuilder sb = new StringBuilder();
            sb.Append(" select Count(SYSTEM_5_10) from SYSTEM_5");
            DataSet ds = DbHelperMySQL.Query(sb.ToString());
            string code = "";
            if (ds!=null && ds.Tables.Count!=0 && ds.Tables[0].Rows.Count!=0)
            {
                code = ds.Tables[0].Rows[0][0].ToString();
            }
            return code;
        }
        /// <summary>
        ///  保存system_5信息
        /// </summary>
        /// <param name="ms">实体信息 通过System_5_10进行判断有System_5_10就是update</param>
        /// <returns>消息</returns>
        public MsReturned Savesystem_5(Mssystem_5 ms)
        {
            MsReturned msr = new MsReturned();
            if (ms.System_5_10 != null && ms.System_5_10.ToString() != "" && ms.System_5_10.ToString() != "0")
            {
                msr = Upsystem_5(ms);
            }
            else
            {
                msr = Addsystem_5(ms);
            }
            return msr;
        }

        /// <summary>
        ///  新增system_5信息
        /// </summary>
        /// <param name="ms">实体信息 通过System_5_10进行判断有System_5_10就是update</param>
        /// <returns>消息</returns>
        public MsReturned Addsystem_5(Mssystem_5 ms)
        {
            List<string> lstResult = new List<string>();
            StringBuilder sb = new StringBuilder();
            List<string> lstCmdText = new List<string>();
            MsReturned msr = new MsReturned();
            int newRateId = DataBase.GetMaxId("system_5", "System_5_10");
            sb.Append("insert into system_5 (");
            sb.Append("System_5_10,System_5_20,System_5_30,System_5_40,System_5_50,");
            sb.Append("System_5_60,System_5_70,System_5_80,System_5_90,System_5_100");
            sb.Append(")");
            sb.Append("values ( ");
            sb.Append(newRateId.ToString()).Append(",");
            sb.Append("@System_5_20,@System_5_30,@System_5_40,@System_5_50,");
            sb.Append("@System_5_60,@System_5_70,@System_5_80,@System_5_90,@System_5_100)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@System_5_10", MySqlDbType.Int32,11),
                    new MySqlParameter("@System_5_20", MySqlDbType.VarChar,200),
                    new MySqlParameter("@System_5_30", MySqlDbType.VarChar,200),
                    new MySqlParameter("@System_5_40", MySqlDbType.VarChar,200),
                    new MySqlParameter("@System_5_50", MySqlDbType.VarChar,200),
                    new MySqlParameter("@System_5_60", MySqlDbType.VarChar,200),
                    new MySqlParameter("@System_5_70", MySqlDbType.VarChar,200),
                    new MySqlParameter("@System_5_80", MySqlDbType.VarChar,200),
                    new MySqlParameter("@System_5_90", MySqlDbType.VarChar,200),
                    new MySqlParameter("@System_5_100", MySqlDbType.VarChar,200)};
            parameters[0].Value = ms.System_5_10;
            parameters[1].Value = ms.System_5_20;
            parameters[2].Value = ms.System_5_30;
            parameters[3].Value = ms.System_5_40;
            parameters[4].Value = ms.System_5_50;
            parameters[5].Value = ms.System_5_60;
            parameters[6].Value = ms.System_5_70;
            parameters[7].Value = ms.System_5_80;
            parameters[8].Value = ms.System_5_90;
            parameters[9].Value = ms.System_5_100;
            lstCmdText.Add(sb.ToString());
            sb.Remove(0, sb.ToString().Length);
            try
            {
                int iexe = DbHelperMySQL.ExecuteSql(lstCmdText[0].ToString(), parameters);
                if (iexe > 0)
                {
                    msr.strMsId = newRateId.ToString();
                    msr.strMS = "保存成功!";
                }
                else
                {
                    msr.strMsId = "-1";
                    msr.strMS = "操作失败:服务器忙,请稍后再试!";
                }
            }
            catch
            {
                msr.strMsId = "-1";
                msr.strMS = "操作失败:服务器忙,请稍后再试!";
            }
            lstCmdText = null;
            sb = null;
            return msr;
        }

        /// <summary>
        ///  更新system_5信息
        /// </summary>
        /// <param name="ms">实体信息 通过System_5_10进行判断有System_5_10就是update</param>
        /// <returns>消息</returns>
        public MsReturned Upsystem_5(Mssystem_5 ms)
        {
            List<string> lstResult = new List<string>();
            StringBuilder sb = new StringBuilder();
            List<string> lstCmdText = new List<string>();
            MsReturned msr = new MsReturned();
            sb.Append("update system_5 set ");
            sb.Append(" System_5_10='").Append(ms.System_5_10).Append("' ");// System_5_10 
            if (ms.System_5_20 != null && ms.System_5_20.ToString() != "")
            {
                sb.Append(",").Append(" System_5_20='").Append(ms.System_5_20).Append("' ");// System_5_20 
            }
            if (ms.System_5_30 != null && ms.System_5_30.ToString() != "")
            {
                sb.Append(",").Append(" System_5_30='").Append(ms.System_5_30).Append("' ");// System_5_30 
            }
            if (ms.System_5_40 != null && ms.System_5_40.ToString() != "")
            {
                sb.Append(",").Append(" System_5_40='").Append(ms.System_5_40).Append("' ");// System_5_40 
            }
            if (ms.System_5_50 != null && ms.System_5_50.ToString() != "")
            {
                sb.Append(",").Append(" System_5_50='").Append(ms.System_5_50).Append("' ");// System_5_50 
            }
            if (ms.System_5_60 != null && ms.System_5_60.ToString() != "")
            {
                sb.Append(",").Append(" System_5_60='").Append(ms.System_5_60).Append("' ");// System_5_60 
            }
            if (ms.System_5_70 != null && ms.System_5_70.ToString() != "")
            {
                sb.Append(",").Append(" System_5_70='").Append(ms.System_5_70).Append("' ");// System_5_70 
            }
            if (ms.System_5_80 != null && ms.System_5_80.ToString() != "")
            {
                sb.Append(",").Append(" System_5_80='").Append(ms.System_5_80).Append("' ");// System_5_80 
            }
            if (ms.System_5_90 != null && ms.System_5_90.ToString() != "")
            {
                sb.Append(",").Append(" System_5_90='").Append(ms.System_5_90).Append("' ");// System_5_90 
            }
            if (ms.System_5_100 != null && ms.System_5_100.ToString() != "")
            {
                sb.Append(",").Append(" System_5_100='").Append(ms.System_5_100).Append("' ");// System_5_100 
            }
            sb.Append(" where System_5_10='").Append(ms.System_5_10).Append("'");// System_5_10 
            lstCmdText.Add(sb.ToString());
            sb.Remove(0, sb.ToString().Length);
            try
            {
                int iexe = DbHelperMySQL.ExecuteSql(lstCmdText[0].ToString());
                if (iexe > 0)
                {
                    msr.strMsId = ms.System_5_10.ToString();
                    msr.strMS = "保存成功!";
                }
                else
                {
                    msr.strMsId = "-1";
                    msr.strMS = "操作失败:服务器忙,请稍后再试!";
                }
            }
            catch
            {
                msr.strMsId = "-1";
                msr.strMS = "操作失败:服务器忙,请稍后再试!";
            }
            lstCmdText = null;
            sb = null;
            return msr;
        }

        /// <summary>
        /// 得到数据类型
        /// </summary>
        /// <param name="msq">条件</param>
        /// <returns>数据类型</returns>
        public MsReturned Getsystem_5ByQuery(MsQuery msq)
        {
            DataSet ds = null;
            MsReturned msr = new MsReturned();
            StringBuilder sb = new StringBuilder();
            List<string> lstCmdText = new List<string>();
            sb.Append("select system_5.* ");
            sb.Append(" from system_5 ");
            sb.Append(" where 1=1 ").Append(msq.strquery);
            if (msq.strorder != null && msq.strorder != "")
            {
                sb.Append(" order by ").Append(msq.strorder);
            }
            lstCmdText.Add(sb.ToString());
            sb.Remove(0, sb.ToString().Length);
            try
            {
                ds = DbHelperMySQL.Query(lstCmdText[0].ToString());
            }
            catch { }
            msr.data = ds;
            return msr;
        }

        /// <summary>
        /// 删除system_5
        /// </summary>
        /// <param name="msq">条件</param>
        /// <returns></returns>
        public MsReturned Deletesystem_5ByQuery(MsQuery msq)
        {
            StringBuilder sb = new StringBuilder();
            MsReturned msr = new MsReturned();
            sb.Append(" delete from system_5 where System_5_10 > 0 ").Append(msq.strquery);
            try
            {
                int iexe = DbHelperMySQL.ExecuteSql(sb.ToString());
                if (iexe > 0)
                {
                    msr.strMsId = "1";
                    msr.strMS = "保存成功!";
                }
                else
                {
                    msr.strMsId = "-1";
                    msr.strMS = "操作失败:服务器忙,请稍后再试!";
                }
            }
            catch
            {
                msr.strMsId = "-1";
                msr.strMS = "操作失败:服务器忙,请稍后再试!";
            }
            sb = null;
            return msr;
        }

    }
}
